<?php
$db['inventory']=array (
  'columns' =>
  array (
    'inventory_id' =>
     array (
      'type' => 'mediumint(8)',
      'required' => true,
      'pkey' => true,
      'extra' => 'auto_increment',
      'label' => '盘点单ID',
    ),
    'inventory_bn' =>
    array (
      'type' => 'varchar(32)',
      'required' => true,
      'width' => 140,
      'label' => '盘点单号',
      'in_list' => true,
      'default_in_list' => true,
      'order' => 40,
    ),
    'inventory_type' =>
    array (
      'type' => 'tinyint(1)',
      'default' => '1',
      'required' => true,
      'width' => 90,
      'label' => '盘点类型',
      'in_list' => true,
      'default_in_list' => true,
      'order'=>10,
    ),
    'op_id' =>
    array (
      'type' => 'mediumint(8)',
      'label' => '申请人ID',
    ),
    'createtime' =>
    array (
      'type' => 'time',
      'label' => '创建时间',
      'width' => '130',
      'in_list' => true,
      'default_in_list' => true,
      'order' => 25,
    ),
    'branch_id' =>
    array (
      'type' => 'mediumint(8)',
      'label' => '门店仓ID',
      'required' => true,
    ),
    'confirm_op_id' =>
    array (
      'type' => 'mediumint(8)',
      'label' => '确认人ID',
      'order' => '20',
    ),
    'confirm_time' =>
    array (
      'type' => 'time',
      'label' => '盘点时间',
      'width' => '130',
      'in_list' => true,
      'default_in_list' => true,
      'order' => 30,
    ),
    'status' =>
    array (
      'type' => 'tinyint(1)',
      'default' => '1',
      'label' => '状态',
      'width' => '70',
      'in_list' => true,
      'default_in_list' => true,
      'order' => 35,
    ),
  ),
  'index' =>
   array (
    'ind_inventory_type' =>
        array (
            'columns' =>
            array (
                0 => 'inventory_type',
            ),
        ),
    'ind_status' =>
        array (
            'columns' =>
            array (
                0 => 'status',
            ),
        ),
    ),
  'comment' => '门店盘点主表',
  'engine' => 'innodb',
  'version' => '$Rev:  $',
);